Shoutbox

Can't get to work the wildcard in this query.

$sql = mysql_query("SELECT * FROM test1 WHERE points='14%'");

And in test1, I have many rows with values like 140, 142, 141, in the points column.

I was reading this tutorial http://www.tizag.com/mysqlTutorial/mysqlwhere.php, and I did exactly what they said there.

What type of data do you store in points? Int, text?

I think the wild cards worked on text... Can't remember, though...

edit:

I think it should be... WHERE points LIKE '14%'

Thank you for your response, well the type of the column is VARCHAR, and numbers are stored there.

quote:

---

Originally posted by leito.gt
Thank you for your response, well the type of the column is VARCHAR, and numbers are stored there.

---

Read my edit.

To use wildcards you must use LIKE.

column LIKE '%data%'

edit again: I didn't remember this at first

Thanks works great!