MySQL Searching

[Anon]

How do you make searches with MySQL???

are there different ways, like with case sensitivity and stuff to make them?

thanx

[doss_]

you use SELECT...and there are diffrent ways....look at http://mysql.com/doc/ and search for SELECT

[Anon]

Jebb Select and you can use "wildcard" that when you are looking for the word "ice" and when you use wildcard you would get ice and iceland and mice

You can use (SELECT * from somebody WHERE $topic = %search%, $message = %search% )

The form that you insert the "searachquery" was named "search", e.g. <form> name="search"

and the tables in database were "topic" and "message" and we match them with the %search% and used % for the wildcard so we could get "Ice" "Iceland" and "Mice"

Hope this helps you understanding how you pick data from mysql with a form quaery.

arnorg
Iceland