How to do a "Begins with" in a MySQLi select statement?
When I create this in Dreamweaver, it creates the following code:
SELECT glossaryID, glossaryWORD, glossaryDESC, glossaryDEL
FROM DGPSTglossary
WHERE glossaryWORD LIKE colname%
ORDER BY glossaryWORD ASC LIMIT 1
...which produces results when you click "Test" but when you click "Advanced" and click "Test" it produces the following error:
MySQL Error#: 2064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '% LIMIT 1' at line 1
Eh? This is the code Dreamweaver created!
Obviously, if you ok all this then there are no results in the recordset on the page.
How to do a "begins with" in a MySQLi select statement?
Thank you.
NJ