this query operation I used the query plug-in ( rummage_ecto ), is the command line test:
iex(4)rummage = %{
...(4)> search: %{name: %{search_type: :like, search_term: "c"}},
...(4)> sort: %{field: :name, order: :asc},
......
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5 MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1eaccd6-46e47.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") MySQL Errno : 1021 Message : Disk full (/tmp/#sql-temptable-64f5-1eaccd6-46e47.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") Need Help?