Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 120409

All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

0
votes
1answer
I have a database with several tables in it. and my web dev. used a big mysql query for admin role home page to give statistics, I believe it is a wrong approach, but I need to learn how to fix it …
asked Mar 24 '17 by Fanar Web
0
votes
1answer
I have This table : SET NAMES utf8; SET time_zone = '+00:00'; CREATE TABLE `app_log` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `serial` int(11) NOT NULL, `dataEntryIP` varchar(255) …
asked Sep 9 '17 by Fanar Web
0
votes
1answer
I have a table like this : serial,ip,term 1,1.2.3.4,bag 2,2.3.4.5,shampoo 3,1.2.3.4,handbag 4,3.4.5.6,clothes 5,2.3.4.5,battery 6,4.5.6.7,lamp I want to select all IPs that did search for multiple …
asked Sep 8 '17 by Fanar Web
0
votes
1answer
I am trying to modify my reports mysql query, the current query is : select `companies`.`companynameturkish` AS `Company_Name`, (round(count(`applications`.`company_id`) / (select count(*) from …
asked May 31 '17 by Fanar Web