SELECT query with OUTER JOIN - problem

Hi, I have two tables, one is containing data about courses and the second one is containing data about course start date. Is it possible to list all courses with one query which should also return earliest scheduled start dates for courses (which are in the second table). I tried something like t

Problem starting MySQL with chroot option

When I try to start the server with the following options mysqld --chroot=/servers/mysql/ --user=mysql (options that are not relevant) I get an error [1] 379 Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! 030128 13:02:21 Aborting 030128 13:02:21 ./mysqld:

WHERE clouse

Hi, Is there a difference in speed between these two querys: SELECT whatever, somethin_else FROM table1 WHERE 1 AND ( table1.whatever='value' OR ) SELECT whatever, somethin_else FROM table1 WHERE table1.whatever='value' OR ... -

Problem with LIKE

Hi i have a problem with searching TEXT columns for appearance of particilur words. Here is the example of what I'm traying to do: mysql> SELECT "Why this does not work" LIKE "work"; +---+ | "Why this does not work" LIKE "work"