Articles tagged with select
Selecting with a different collation in MySQL
You can select from a table and set the collation to be used for the search.
[code]
SELECT * FROM my_table WHERE my_field = 'hallå';
SELECT * FROM my_tab
Inserting from a select in MySQL
Quite simple but something I can never seem to remember:
INSERT INTO files_users (file_id, user_id)
SELECT id, '2' FROM efs.files;
found @ http://mysq
