Likes Received By chisara
-
timallard liked chisara's post in the thread Most Popular In Column.
What jesteps query does is the following: SELECT items, COUNT(items) FROM colors GROUP BY color ORDER BY COUNT(items) DESC By using a...
Apr 30, 2009 -
greatlogix liked chisara's post in the thread Search product name both ways?.
select * FROM tblproducts WHERE prodName (LIKE lower('%$keyword1%')) AND (LIKE lower('%$keyword2%')) You should split you search...
Feb 6, 2009 -
Tom Thumb liked chisara's post in the thread Need help with last updated record in Mysql.
SELECT Rownum, Status, Name, StudentNumber, Date FROM mytable WHERE CONCAT(StudentNumber,date) IN (SELECT CONCAT...
Feb 2, 2009 -
olegb liked chisara's post in the thread How to extract 3 mysql rows - 2 random and one not.
(SELECT correct_answer FROM mytable WHERE question=X) UNION (SELECT correct_answer FROM mytable WHERE question IS NOT X ORDER BY RAND()...
Dec 26, 2008 -
shenron liked chisara's post in the thread How to extract 3 mysql rows - 2 random and one not.
(SELECT correct_answer FROM mytable WHERE question=X) UNION (SELECT correct_answer FROM mytable WHERE question IS NOT X ORDER BY RAND()...
Dec 25, 2008 -
wing liked chisara's post in the thread Can MySQL handle very high traffic?.
I suspect that most databases could handle 1000 connections (concurrent / new) connections / minute as long as they are idle. If it can...
Oct 18, 2008 -
chandan123 liked chisara's post in the thread help opening and uploading a large database.
Which in my humble opinion is the root cause of the problem, bigdump is good as a solution for the symptoms. The best advice when one...
Oct 4, 2008 -
movingconcierge liked chisara's post in the thread help opening and uploading a large database.
Assuming your assusing Mysql as your databse server and you are using something like phpmyadmin. Altough I have not used it myself,...
Oct 4, 2008 -
Cal813 liked chisara's post in the thread table help..
SELECT THREADID, SUM(VOTE) FROM VOTETABLE GROUP BY THREADID; That should do the trick keep in mind that this query can become rather...
Sep 30, 2008 -
The Stealthy One liked chisara's post in the thread PostgreSQL vs. MySQL.
Search the forums you will find some other people asking roughly the same thing....
Sep 29, 2008 -
Masterful liked chisara's post in the thread What's Wrong with My SELECT Query?.
You left me wondering what you want to achieve since now you are encoding information into your column names. This usually means...
Sep 15, 2008