What is the difference between % and * in MySQL?
In a question like this: "SELECT * FROM $ table WHERE MATCH (message) about ('$ string *' in Boolean mode)"
* is used only in a full text search as a wildcard (or typing) Can be done while % (match with 0 or more characters) and _ (one letter corresponds) apply only in the preference-queries.
Comments
Post a Comment