Search Script

Hell everyone, I've been making a search script for my website. Iam having troubles with the MySQL databasing though.

What object would query a table for keywords...

Thanks

Heres a few ive used:

PHP Code:

---

# general search
WHERE search_field LIKE '%".$_GET['q']."%' 


---

PHP Code:

---

# starts with letter "whatever"
WHERE search_field LIKE '".$_GET['q']."%'' 


---

PHP Code:

---

# startes with number
WHERE search_field LIKE '[0-9]%'' 


---

PHP Code:

---

# working with numbers, greated-then and less-then
WHERE search_field < '1970' 


---

_

Ok so the code

PHP Code:

---

# general search 
WHERE search_field LIKE '%".$_GET['q']."%' 


---

Basically searches for keywords 'q',

Nope...

$_GET['q']
Will pull the info attached to the url.com?q=whatever

This would search for the keyword q

PHP Code:

---

WHERE search_field LIKE '%q%' 


---

PHP Code:

---

WHERE search_field LIKE '%search word%' 


---

_

Ok great thanks for the help!