Posts Tagged 'mysql'

sql Tip 3: getting DB schema in MYSQL

Categorized Under: Development, English one Commented

long time since my last post here, well i was bit busy , hopefully i will not stop bloging for long times again.
for this blog the title actually shouldn’t be SQL tip 3 , it should be MYSQL tip 3, since it is talking about something specific to MYSQL, but since i had two [...]

SQLTip1: search database faster without like

Categorized Under: Development, English 4 Commented

SQL tip 2, SQL tip 3well all of us need to deal with databases and sql query and most of the time we need to provide searching abilities to users.
well the easiest way is using like i.e to search articles containing the word “database” this query is goo enough “Select title from articles where [...]