Searching!

[infernofiasco]

What sql statements wud be easiest way of searching through a database? Also so the search will allow parts of words to be found not certain words?

[Purple Martin]

Searching:

SELECT * FROM blah WHERE blah = 'blah' OR blah = 'blah'

For part-of-word searches, use LIKE instead of = and use % as a wildcard.

[infernofiasco]

SELECT Fname
FROM mysql.site
WHERE Fname like 'MMColParam%'

That works but only if i use the whole word? And if i wanted to use all the fields (Fname etc) would i use '*'

[Purple Martin]

You use * to return all fields.

To search all fields, you need to tell it to search each field in turn using OR:

SELECT blahField FROM blahTable WHERE field1 = 'blah' OR field2 = 'blah' OR ... etc

For part of a word: use part of the word and % as a wildcard. Look carefully at what you've got at the moment. It's looking for the whole word: if MMColParam is 'table', you'll be getting results that match 'table' plus any other characters, eg:
'table'
'tables'
'tabletop'
but not part of the word eg:
'tab'

To return matches on part of the word, you have to search for part of the word, not the whole word. I hope that makes sense.