Category Archives: MySQL

MySQL fulltext searches

January 13, 2009 Jesper MySQL

MySQL have a very nifty search function built in, which in many ways are more sophisticated than the WHERE LIKE (‘%’). Using full text search with MATCH (…) AGAINST (…) AS relevancy it is also possible to get results ranked … Continue reading →

Popularity: 5% [?]

Comments Off

Selecting / joining two tables in MySQL – explained

November 28, 2008 Jesper MySQL

Trying to create MySQL queries can be a daunting task for the beginner and before understanding the logic it can be really confusing. A common task is to select related data from two tables to generate for example a list … Continue reading →

Popularity: 5% [?]

Comments Off

Select a random row (like user or post) from your MySQL table

September 15, 2008 Jesper MySQL

I have beein using all kinds of strange constructs to be able to select a random row (often user or post) from table, and then I stubled over this on sitepoint forums: SELECT * FROM users WHERE age > 20 … Continue reading →

Popularity: 10% [?]

Comments Off