Using Aliases and Fulltext
Posted: Wed Nov 23, 2005 4:17 pm
I have a column in a table called 'names'
A Fulltext index was created in the CREATE table definition with FULLTEXT (names)
My SELECT query is like so:
Can I do this??? Can I use a column's alias in a fulltext WHERE clause??? Thanks.
A Fulltext index was created in the CREATE table definition with FULLTEXT (names)
My SELECT query is like so:
Code: Select all
"SELECT names AS n FROM table WHERE MATCH(n) AGAINST('my keywords')";