But I need results where my word is on beginnig of the string or in the middle with space before it.
In example if I search for test, I want next records:
test
test drive
dope test
I don't want to display: testing
ikrajinovic
Last Activity: Jun 11 '12, 12:09 PM
Joined: Apr 29 '12
Location:
-
I've been thinking about that. I'm not sure how to do that. Can you please help me?Leave a comment:
-
What is a difference between your code and mine?Leave a comment:
-
I don't want to use
becouse I want to show only records that contains my search word at beginning of the record.Code:var1 LIKE '% ".$searchWord." %'
Leave a comment:
-
Select from multiple tables
Hi guys,
I have four table with the same structure (id, var1, var2)
Table 1 in var1 have only one word (150000+ records)
Table 2 in var1 have two words (50000+ records)
Table 3 in var1 have three words (50000+ records)
Table 4 in var1 have four or more words (30000+ records)
What is the best way to search them?
I do search with UNION as following:
...Code:SELECT * FROM (
No activity results to display
Leave a comment: