473,320 Members | 1,881 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

any way to perform a fulltext search on a string less than four characters (e.g. PHP?)

Does anyone know of a way to perform a fulltext search (PHP/MYSQL) on
a string less than 4 characters in length?

e.g. if searching for 'PHP' ?

I thought about a boolean search adding * before/after the search
string -
*PHP*' - however that doesn't seem to work either...

TIA

--
John McClumpha
Darkness Reigns - http://www.incitegraphics.com.au/darkness/
Nov 23 '05 #1
2 1818
not sure if that's what you're looking for:

SELECT * FROM some_table WHERE some_column LIKE '%PHP%'

Nov 24 '05 #2
John McClumpha wrote:
Does anyone know of a way to perform a fulltext search (PHP/MYSQL) on
a string less than 4 characters in length?

e.g. if searching for 'PHP' ?
<?
$sentence = 'A string that contains PHP, the name of this language';

if ( strpos($sentence, 'PHP') !== FALSE )
echo "Found PHP in the string";
?>
I thought about a boolean search adding * before/after the search
string -
*PHP*' - however that doesn't seem to work either...

TIA

--
John McClumpha
Darkness Reigns - http://www.incitegraphics.com.au/darkness/


Nov 24 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: leegold2 | last post by:
Right now on a form I have the instructions below, the mysql FullText search works nicely when done manually w/these instructions. I'm thinking of replacing the text the user sees below with some...
0
by: Peter Engström | last post by:
Hi! I'm running MySQL 4.0.13 and have problem with fulltext search. I have a column of type 'text' which I fulltext index. I want to search for an e-mail address but I don't get any matches....
0
by: Matt W | last post by:
Hi all, I'm planning to use MySQL's full-text search for my forum system (possibly 5+ million posts). I've been playing with it a lot lately to see the performance and functionality and have...
0
by: leegold2 | last post by:
I want to know on Solaris how I could lower the the minimum fulltext search string from 4 to 3. Right now using the FullText search any string less than 4 chars is ignored. I'm sure there's a link...
0
by: Robert Oschler | last post by:
I read a while back that MySQL will only use one index per query. (If this is not so, please tell me and point me to a doc that gives a good explanation of MySQL's current index usage policy). ...
1
by: Robert Oschler | last post by:
I read a while back that MySQL will only use one index per query. (If this is not so, please tell me and point me to a doc that gives a good explanation of MySQL's current index usage policy). ...
32
by: tshad | last post by:
Can you do a search for more that one string in another string? Something like: someString.IndexOf("something1","something2","something3",0) or would you have to do something like: if...
0
by: mossy | last post by:
I am refining the search within a small IT Jobs Website developed in C#. I am using FULLTEXT search on 3 columns (title, short_desc, long_desc), but am having trouble becuase some queries for the...
4
by: odysseyphotography | last post by:
Hi, I'm building a PHP site hosted on a commerical server (i.e. no access to MySQL system variables, only PHPMyAdmin). My client wants a FULLTEXT search on the site, but the most likely term...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.