Tag: SQL
In SQL, sometimes, you want to search a string field that contains a keyword, but as a whole word. So for example, if you search for ‘word‘, you do …
October 4, 2013
algorithms, database, implementation, internet, mysql, optimization, php, programming languages, search, SEO, sorting, technical, tricks
I have created an online page that allows people to upload any single photo to server. The URL to list all the photos (visible) is https://rot47.net/picture-gallery To add a photo …
My FTP provider (fasthosts) only allows 150MB maximum usage per database created. This is big enough for most personal usages. However, the other day, after I logined to the …
The problem is from codeforces: http://www.codeforces.com/problemset/problem/228/A The answer is to count the unique number of integers and substract from four. The SQL to the answer is: select 4 - …
Sometimes if you want to extract some records from a table you can use the following SQL syntax select * from table order by rand() limit 10 Different SQL …