2
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by jrdark13
0

the wild card I think your looking for is % within the MySQL command.

so in the phrase "blue house"
so...
"%house" = TRUE;
"blue%" = TRUE;

"%blue" = FALSE;
"house%" = FALSE;

"%blue%" = TRUE;
"%house%" = TRUE;

example mysql command:

SELECT * FROM `table` WHERE `col` LIKE CONVERT( _utf8 '%blue%' USING latin1 ) COLLATE latin1_swedish_ci LIMIT 0 , 30
0

Ok please let me know how can I do this ? I had a text box in the first page and a submit button. User will enter word(s) and hit submit. Then what code I need to wrote in next page ??? My database name is "shopping_data"
Please help me ...
Thanks

0

I'd probably rather let you know that this tutorial seems really informative...
http://www.webreference.com/programming/php/search/

It seems like a really good tutorial.

I'm not trying to be lazy or a pain in the **** but I think you'll benefit better from the tutorial instead of giving you the answer.

Check it out and if you run into problems ask again and I'll help you out.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.